RM Open File Debit Copy (RM20101)

azurecurve Products Microsoft Dynamics GP (0)SalesRM Open File Debit Copy (RM20101)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM20101

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Open File
Physical Name: RM20101
Technical Name: RM_OPEN

Group Display Name: Receivables Open Transaction Files
Group Technical Name: RM_Open_Transaction_Logical_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['RM Open File'].CUSTNMBR AS 'RM Open File-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM RM20101 AS ['RM Open File'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['RM Open File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	CPRCSTNM	Corporate Customer Number	String	STR15_RM_Customer_Number	15
3	DOCNUMBR	Document Number	String	STR20_Document_Number	20
4	CHEKNMBR	Check Number	String	STR20_Document_Number	20
5	BACHNUMB	Batch Number	String	STR15_LBAU	15
6	BCHSOURC	Batch Source	String	STR15	15
7	TRXSORCE	TRX Source	String	STR13	13
8	RMDTYPAL	RM Document Type-All	Integer	INT2	2
	Document Type records the type of document. Click to show/hide the Document Types 0 Balance Carried Forward 1 Sales / Invoice 2 Scheduled Payments 3 Debit Memo 4 Finance Charge 5 Service Repairs 6 Warranties 7 Credit Memo 8 Returns 9 Payments
9	CSHRCTYP	Cash Receipt Type	Integer	GB	0
10	CBKIDCRD	Checkbook ID Credit Card	String	STR15_Checkbook_ID	15
11	CBKIDCSH	Checkbook ID Cash	String	STR15_Checkbook_ID	15
12	CBKIDCHK	Checkbook ID Check	String	STR15_Checkbook_ID	15
13	DUEDATE	Due Date	Date	DT	8
14	DOCDATE	Document Date	Date	DT	8
15	POSTDATE	Post Date	Date	DT_Date	6
16	PSTUSRID	Post User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['RM Open File'].PSTUSRID AS 'RM Open File-Post User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM RM20101 AS ['RM Open File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['RM Open File'].PSTUSRID = ['Users Master'].USERID
17	GLPOSTDT	GL Posting Date	Date	DT	8
18	LSTEDTDT	Last Edit Date	Date	DT_Date	6
19	LSTUSRED	Last User to Edit	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['RM Open File'].LSTUSRED AS 'RM Open File-Last User to Edit' ,['Users Master'].USERID AS 'Users Master-User ID' FROM RM20101 AS ['RM Open File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['RM Open File'].LSTUSRED = ['Users Master'].USERID
20	ORTRXAMT	Original Trx Amount	Currency	DLR17_RBS0_STR$	17
21	CURTRXAM	Current Trx Amount	Currency	DLR17_RBS0_UTR$	17
22	SLSAMNT	Sales Amount	Currency	DLR19_RBSO_UTR$	19
23	COSTAMNT	Cost Amount	Currency	DLR19_RBSO_UTR$	19
24	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
25	MISCAMNT	Misc Amount	Currency	DLR17_RBS0_UTR$	17
26	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
27	COMDLRAM	Commission Dollar Amount	Currency	DLR17_RBSO_STR$	17
28	CASHAMNT	Cash Amount	Currency	DLR19_RBS0_UTR$	19
29	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
30	DISAVAMT	Discount Available Amount	Currency	DLR17_RBS0_UTR$	17
31	DISAVTKN	Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
32	DISCRTND	Discount Returned	Currency	DLR17_RBS0_STR$	17
33	DISCDATE	Discount Date	Date	DT	8
34	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
35	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
36	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
37	TRXDSCRN	Transaction Description	String	STR30	30
38	CSPORNBR	Customer Purchase Order Number	String	Document_Number	20
39	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['RM Open File'].SLPRSNID AS 'RM Open File-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM RM20101 AS ['RM Open File'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['RM Open File'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
40	SLSTERCD	Sales Territory Code	String	STR15	15
41	DINVPDOF	Date Invoice Paid Off	Date	DT	8
42	PPSAMDED	PPS Amount Deducted	Currency	DLR17_RBS0_UTR$	17
43	GSTDSAMT	GST Discount Amount	Currency	DLR17_RBS0_STR$	17
44	DELETE1	Delete	Boolean	YN	0
45	AGNGBUKT	Aging Bucket	Integer	INT1_U0	1
46	VOIDSTTS	Void Status	Integer	INT	0
47	VOIDDATE	Void Date	Date	DT	8
48	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['RM Open File'].TAXSCHID AS 'RM Open File-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM RM20101 AS ['RM Open File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['RM Open File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
49	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['RM Open File'].CURNCYID AS 'RM Open File-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM RM20101 AS ['RM Open File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['RM Open File'].CURNCYID = ['Currency Setup'].CURNCYID
50	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['RM Open File'].PYMTRMID AS 'RM Open File-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM RM20101 AS ['RM Open File'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['RM Open File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
51	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['RM Open File'].SHIPMTHD AS 'RM Open File-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM RM20101 AS ['RM Open File'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['RM Open File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
52	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
53	SLSCHDID	Sales Schedule ID	String	STR15_LBU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['RM Open File'].SLSCHDID AS 'RM Open File-Sales Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM RM20101 AS ['RM Open File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['RM Open File'].SLSCHDID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
54	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['RM Open File'].FRTSCHID AS 'RM Open File-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM RM20101 AS ['RM Open File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['RM Open File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
55	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['RM Open File'].MSCSCHID AS 'RM Open File-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM RM20101 AS ['RM Open File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['RM Open File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
56	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['RM Open File'].NOTEINDX AS 'RM Open File-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM RM20101 AS ['RM Open File'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['RM Open File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
57	Tax_Date	Tax Date	Date	DT	8
58	APLYWITH	Apply Withholding	Boolean	Boolean	0
59	SALEDATE	Sale Date	Date	DT	8
60	CORRCTN	Correction	Boolean	CB_Correction	0
61	SIMPLIFD	Simplified	Boolean	CB_Simplified	0
62	Electronic	Electronic	Boolean	CB_Electronic	0
63	ECTRX	EC Transaction	Boolean	CB_EC_Transaction	0
	The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction. Click to show/hide Document Printed flag 0 Not an EU Transaction. 1 EU Transaction.
64	BKTSLSAM	Backout Sales Amount	Currency	DLR19_RBS0_UTR$	19
65	BKTFRTAM	Backout Freight Amount	Currency	DLR19_RBS0_UTR$	19
66	BKTMSCAM	Backout Misc Amount	Currency	DLR19_RBS0_UTR$	19
67	BackoutTradeDisc	Backout Trade Discount Amount	Currency	DLR19_RBS0_UTR$	19
68	Factoring	Factoring	Boolean	boolean	0
69	DIRECTDEBIT	Direct Debit	Boolean	CB_DirectDebit	0
70	ADRSCODE	Address Code	String	STR15_Address_Code	15
71	EFTFLAG	EFT Flag	Boolean	CB_EFT	0

azurecurve Products Microsoft Dynamics GP (0)SalesRM Open File Debit Copy (RM20101)

2 thoughts on “RM Open File Debit Copy (RM20101)”

Nipuni says:

29th June 2021 at 1209

What are the other related table with RM_OPEN. Is there any header and line level tables related?
I’m looking for SQL tables when saving credit memo document.

Thanks

1. iangrieve says:
  
  29th June 2021 at 1323
  
  Clicking on the Group Display Name or Group Technical Name at the top of the page will show you the other tables in the group which will include headers, lines, taxes and so on.

2 thoughts on “RM Open File Debit Copy (RM20101)”

Leave a Reply Cancel reply